mail.altrad.com/2015.02.mail.altrad.com.tar/mail.altrad.com/TEST/office deutch/ACCESS.NL-NL/ACCLR.CAB/ACCESS_TEMPLATE_FACULTY.ACCDT_1043/template/database/objects/queryFacultyExtended.txt

Text File | 2006-11-12 | 3KB | 92 lines

Operation =1
Option =0
Begin InputTables
    Name ="Faculty"
End
Begin OutputColumns
    Alias ="Opslaan als"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \", \" & [First Name]))"
    Alias ="Contactpersoon"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & \" \" & [Last Name]))"
    Expression ="Faculty.*"
End
Begin OrderBy
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \", \" & [First Name]))"
    Flag =0
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & \" \" & [Last Name]))"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbByte "RecordsetType" ="0"
dbBoolean "TotalsRow" ="0"
dbBinary "GUID" = Begin
    0x8bb1892290b04a4d9b904c0f2871c057
End
dbLongBinary "DOL" = Begin
    0x0acc0e5500000000ab6397e9fa59e6489c9a9ef875cb329a000000005253566c ,
    0x570ae340010000004029283446006100630075006c0074007900000000000000 ,
    0xa07813be085ff249aae6fd9e2988b7cd070000008bb1892290b04a4d9b904c0f ,
    0x2871c057460069006c00650020004100730000000000000003f5339da9076d4a ,
    0xae1e33c02b04686a070000008bb1892290b04a4d9b904c0f2871c05743006f00 ,
    0x6e00740061006300740020004e0061006d00650000000000000019c853d3c1ab ,
    0x0249a2ca235a4cff9b3f07000000ab6397e9fa59e6489c9a9ef875cb329a4c00 ,
    0x61007300740020004e0061006d006500000000000000d59333a5d01a7340b33c ,
    0xc1b4956b48ee07000000ab6397e9fa59e6489c9a9ef875cb329a460069007200 ,
    0x7300740020004e0061006d00650000000000000052304034cee838409eddf5a6 ,
    0xcf79599a07000000ab6397e9fa59e6489c9a9ef875cb329a43006f006d007000 ,
    0x61006e007900000000000000000000000000000000000000000000000c000000 ,
    0x040000000000000000000000000000000000
End
Begin
    Begin
        dbText "Name" ="Contactpersoon"
        dbInteger "ColumnOrder" ="1"
        dbInteger "ColumnWidth" ="1695"
        dbBoolean "ColumnHidden" ="0"
        dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x03f5339da9076d4aae1e33c02b04686a
        End
    End
    Begin
        dbText "Name" ="Opslaan als"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="2"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0xa07813be085ff249aae6fd9e2988b7cd
        End
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =799
    Bottom =520
    Left =-1
    Top =-1
    Right =784
    Bottom =268
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="Faculty"
        Name =""
    End
End